package cn.ac.siom.query.service.impl;

import cn.ac.siom.query.dao.ITab_ThesisDao;
import cn.ac.siom.query.service.ITab_ThesisService;
import cn.ac.siom.query.vo.Tab_Thesis;
import cn.ac.siom.query.vo.resultType_jl;
import org.springframework.stereotype.Service;

import javax.annotation.Resource;
import java.sql.SQLException;
import java.util.List;

@Service
public class Tab_ThesisServiceImpl implements ITab_ThesisService {

    @Resource
    private ITab_ThesisDao tab_ThesisDao;


    @Override
    public List<Tab_Thesis> list_Books() throws SQLException {
        List<Tab_Thesis> list = this.tab_ThesisDao.findAll();
        return  list;
    }

    @Override
    public List<Tab_Thesis> list_Report() throws SQLException {
        List<Tab_Thesis> list =  this.tab_ThesisDao.findReport();
        return  list;
    }

    @Override
    public List<Tab_Thesis> findBookSection() throws SQLException {
        return this.tab_ThesisDao.findBookSection();
    }

    @Override
    public List<Tab_Thesis> list_Journal() throws SQLException {
        List<Tab_Thesis> list =  this.tab_ThesisDao.findJournal();
        return  list;
    }

    @Override
    public List<Tab_Thesis> list_Conference() throws SQLException {
        List<Tab_Thesis> list =  this.tab_ThesisDao.findConference();
        return  list;
    }

    @Override
    public List<Tab_Thesis> list_NO(Integer i_id) throws SQLException {
        List<Tab_Thesis> tab_Thesis=this.tab_ThesisDao.findNo(i_id);
        return tab_Thesis;
    }

    @Override
    public List<Tab_Thesis> list_Search(Integer rownum, Integer page_id,String keywords) throws SQLException {
        return this.tab_ThesisDao.findSearch(rownum,page_id,keywords);
    }

    public Integer search_count(String keywords) throws SQLException {
        Integer tab_Thesis=this.tab_ThesisDao.searchCount(keywords);
        return tab_Thesis;
    }
    @Override
    public List<Tab_Thesis> list_page(Integer rownum, Integer page_id,String keywords) throws SQLException {
        List<Tab_Thesis> tab_Thesis=this.tab_ThesisDao.findPage(rownum,page_id,keywords);
        return tab_Thesis;
    }

    @Override
    public Integer list_count(String keywords) throws SQLException {
        Integer tab_Thesis=this.tab_ThesisDao.findCount(keywords);
        return tab_Thesis;
    }

    @Override
    public Tab_Thesis list_reference(Integer i_id) throws SQLException {
        return this.tab_ThesisDao.list_reference(i_id);
    }

    @Override
    public List<Tab_Thesis> list_tj(Integer i_id) throws SQLException {
        return this.tab_ThesisDao.findNO_tj(i_id);
    }

    @Override
    public List<Tab_Thesis> list_page_tj(Integer rownum, Integer page_id) throws SQLException {
        return this.tab_ThesisDao.findPage_tj(rownum,page_id);
    }

    @Override
    public Integer list_count_tj() throws SQLException {
        return this.tab_ThesisDao.findCount_tj();
    }

    @Override
    public List<Tab_Thesis> list_ByBooksID(String id) throws SQLException {
        return this.tab_ThesisDao.find_Bybooks(id);
    }

    @Override
    public List<Tab_Thesis> list_Search_jl( Integer page_id, String keywords, Integer type,String mold) throws SQLException {
        return this.tab_ThesisDao.findSearch_jl(page_id,keywords,type,mold);
    }

    @Override
    public List<resultType_jl> search_count_jl(String keywords, String mold) throws SQLException {
        return this.tab_ThesisDao.searchCount_jl(keywords,mold);
    }

    @Override
    public Integer CountPage_jl(String keywords, String value, Integer type) throws SQLException {
        return this.tab_ThesisDao.CountPage_jl(keywords,value,type);
    }

    @Override
    public List<Tab_Thesis> list_kj(Integer i_id) throws SQLException {
        return this.tab_ThesisDao.findNO_kj(i_id);
    }

    @Override
    public List<Tab_Thesis> list_page_kj(Integer rownum, Integer page_id) throws SQLException {
        return this.tab_ThesisDao.findPage_kj(rownum,page_id);
    }

    @Override
    public Integer list_count_kj() throws SQLException {
        return this.tab_ThesisDao.findCount_kj();
    }

    @Override
    public List<Tab_Thesis> list_kj_home() throws SQLException {
        return this.tab_ThesisDao.finhome_kj();
    }

    // write by hx
    @Override
    public Integer count1() throws SQLException {
        return this.tab_ThesisDao.count1();
    }

    @Override
    public List<Tab_Thesis> search1(Integer pageid, String mold, Integer type) throws SQLException {
        return this.tab_ThesisDao.search1(pageid, mold, type);
    }

    @Override
    public List<resultType_jl> stat1(String mold) throws SQLException {
        return this.tab_ThesisDao.stat1(mold);
    }

    @Override
    public Integer count2() throws SQLException {
        return this.tab_ThesisDao.count2();
    }

    @Override
    public List<Tab_Thesis> search2(Integer pageid, String mold, Integer type) throws SQLException {
        return this.tab_ThesisDao.search2(pageid, mold, type);
    }

    @Override
    public List<resultType_jl> stat2(String mold) throws SQLException {
        return this.tab_ThesisDao.stat2(mold);
    }

    @Override
    public Integer count3() throws SQLException {
        return this.tab_ThesisDao.count3();
    }

    @Override
    public List<Tab_Thesis> search3(Integer pageid, String mold, Integer type) throws SQLException {
        return this.tab_ThesisDao.search3(pageid, mold, type);
    }

    @Override
    public List<resultType_jl> stat3(String mold) throws SQLException {
        return this.tab_ThesisDao.stat3(mold);
    }

    @Override
    public Integer count4() throws SQLException {
        return this.tab_ThesisDao.count4();
    }

    @Override
    public List<Tab_Thesis> search4(Integer pageid, String mold, Integer type) throws SQLException {
        return this.tab_ThesisDao.search4(pageid, mold, type);
    }

    @Override
    public List<resultType_jl> stat4(String mold) throws SQLException {
        return this.tab_ThesisDao.stat4(mold);
    }

    @Override
    public Integer count5() throws SQLException {
        return this.tab_ThesisDao.count5();
    }

    @Override
    public List<Tab_Thesis> search5(Integer pageid, String mold, Integer type) throws SQLException {
        return this.tab_ThesisDao.search5(pageid, mold, type);
    }

    @Override
    public List<resultType_jl> stat5(String mold) throws SQLException {
        return this.tab_ThesisDao.stat5(mold);
    }

    @Override
    public List<Tab_Thesis> combSearch(Integer page_id, String title, String author, String publisher, String metting, String op1, String op2, String op3) throws SQLException {
        return this.tab_ThesisDao.combSearch(page_id,  title,  author,  publisher,  metting,  op1,  op2,  op3);
    }

    @Override
    public Integer combSearchCount(Integer page_id, String title, String author, String publisher, String metting, String op1, String op2, String op3) throws SQLException {
        return this.tab_ThesisDao.combSearchCount(page_id,  title,  author,  publisher,  metting,  op1,  op2,  op3);
    }

    @Override
    public List<resultType_jl> combSearchStat(String title, String author, String publisher, String metting, String op1, String op2, String op3, String mold) throws SQLException {
        return this.tab_ThesisDao.combSearchStat(title,  author,  publisher,  metting,  op1,  op2,  op3, mold);
    }
}

